Introduction
Here is a study of timeseries to evaluate the data we have and be able to discretize the time.
Index:
- Speed.
- Intersession time.
- Standard deviation.
With this first approach we can see the almost total absence of points on the weekends. Also, very few points at night in all edges. Most points are under 50km/h.
Timeseries
Speed Boxplot.
Median is under 5km/h for every hour and percentile 75 under 30km/h. At 13h is the time with less difference and lowest speed records.
Boxplot intersession time
The intersession time median it is not even under 60min for every edge. Frei’s st. shows an intersession time way smaller than the rest.

All speed timeseries per way_id
Avg speed by session and then time.
[[1]]
[[2]]
[[3]]
[[4]]
[[5]]
[[6]]
[[7]]
[[8]]
[[9]]









Hour

Week day

Day

Average of speed of every point.
Number of sessions
- We can see usually a incremental of number of sessions along the week. Being thursdays and fridays the one with most sessions. *The drop in day 25th it is because holiday.
[[1]]
[[2]]
[[3]]
[[4]]
[[5]]
[[6]]
[[7]]
[[8]]
[[9]]
NA
Average speed
[[1]]
[[2]]
[[3]]
[[4]]
[[5]]
[[6]]
[[7]]
[[8]]
[[9]]
NA
Intersession time
Error in df_intersession_april16pt %>% filter(way_id == df_osm_edge_ids[index, :
could not find function "%>%"
Density lines average speed all together
Standard deviation
By hour

By day and hour

By session

–>
LS0tCnRpdGxlOiAiVGltZXNlcmllcyBhbmFseXNpcyB0b3AgZWRnZXMiCm91dHB1dDogCiAgaHRtbF9ub3RlYm9vazoKICB0b2M6IHRydWUKLS0tCgojIEludHJvZHVjdGlvbiAKCkhlcmUgaXMgYSBzdHVkeSBvZiB0aW1lc2VyaWVzIHRvIGV2YWx1YXRlIHRoZSBkYXRhIHdlIGhhdmUgYW5kIGJlIGFibGUgdG8gZGlzY3JldGl6ZQp0aGUgdGltZS4gCgojIyMjIEluZGV4OiAKCiAgKiBTcGVlZC4KICAqIEludGVyc2Vzc2lvbiB0aW1lLgogICogU3RhbmRhcmQgZGV2aWF0aW9uLiAKCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCgpgYGB7ciBlY2hvPUZBTFNFfQpzb3VyY2UoIi4uL3JzY3JpcHRzL3BhY2thZ2VzLlIiKQpzb3VyY2UoIi4uL3JzY3JpcHRzL3RpbWVzZXJpZXMuUiIpCmBgYAoKV2l0aCB0aGlzIGZpcnN0IGFwcHJvYWNoIHdlIGNhbiBzZWUgdGhlIGFsbW9zdCB0b3RhbCBhYnNlbmNlIG9mIHBvaW50cyAgb24gdGhlIHdlZWtlbmRzLiAKQWxzbywgdmVyeSBmZXcgcG9pbnRzIGF0IG5pZ2h0IGluIGFsbCBlZGdlcy4gCk1vc3QgcG9pbnRzIGFyZSB1bmRlciA1MGttL2guCgpgYGB7ciBlY2hvPUZBTFNFfQpsYXBwbHkoMTo5LCBGVU4gPSB0c2VyaWVzX2xpZ2h0KQpgYGAKCiNUaW1lc2VyaWVzIAoKIyMgU3BlZWQgQm94cGxvdC4KCk1lZGlhbiBpcyB1bmRlciA1a20vaCBmb3IgZXZlcnkgaG91ciBhbmQgcGVyY2VudGlsZSA3NSB1bmRlciAzMGttL2guCkF0IDEzaCBpcyB0aGUgdGltZSB3aXRoIGxlc3MgZGlmZmVyZW5jZSBhbmQgbG93ZXN0IHNwZWVkIHJlY29yZHMuIApgYGB7ciBlY2hvPUZBTFNFfQojQm94cGxvdHMgYWxsIApkZl9zdXBlcmhvdGVkZ2VzX2FwcmlsMTZwdCAlPiUgCiAgZmlsdGVyKHNwZWVkID4gMCwgd2RheSh0aW1lKSAhPSAxICwgd2RheSh0aW1lKSAhPSA3ICkgJT4lIAogIGdyb3VwX2J5KGhvdXIgPSBob3VyKHRpbWUpKSAlPiUgCiAgcGxvdF9seSh4PSB+ZmFjdG9yKGhvdXIpLCB5PSB+KHNwZWVkKjE4KS81LCB0eXBlID0gJ2JveCcsYm94cG9pbnRzID0gRkFMU0UpICU+JSAKICBsYXlvdXQodGl0bGUgPSBwYXN0ZSgiQXZnIHNwZWVkIHBlciBob3VyIChXVykiICksCiAgICAgICAgIHlheGlzID0gbGlzdCh0aXRsZT0iU3BlZWQgKGttL2gpIiksCiAgICAgICAgIHhheGlzID0gbGlzdCh0aXRsZT0iSG91ciIpKQpgYGAKCgojIyBCb3hwbG90IGludGVyc2Vzc2lvbiB0aW1lICAKClRoZSBpbnRlcnNlc3Npb24gdGltZSBtZWRpYW4gaXQgaXMgbm90IGV2ZW4gdW5kZXIgNjBtaW4gZm9yIGV2ZXJ5IGVkZ2UuCkZyZWkncyBzdC4gc2hvd3MgYW4gaW50ZXJzZXNzaW9uIHRpbWUgd2F5IHNtYWxsZXIgdGhhbiB0aGUgcmVzdC4gCmBgYHtyIGVjaG89RkFMU0V9CiNCb3hwbG90cyBhbGwgCmRmX2ludGVyc2Vzc2lvbl9hcHJpbDE2cHQgJT4lCiAgc3Vic2V0KHdheV9pZCAlaW4lIGRmX3N1cGVyaG90ZWRnZXNfYXByaWwxNnB0JHdheV9pZCkgJT4lIAogIG1lcmdlKHkgPSBkZl9vc21fZWRnZV9pZHMsIHVzaW5nID0gd2F5X2lkKSAlPiUgCiAgZ2dwbG90KGFlcyhmYWN0b3IoYWRkcmVzcyksIGludGVyc2Vzc2lvbl90aW1lKSkgKwogIGdlb21fYm94cGxvdCgpICsKICBjb29yZF9jYXJ0ZXNpYW4oeWxpbT0gYygwLDI1MCkpKwogIGdndGl0bGUobGFiZWwgPSAiSW50ZXJzZXNzaW9uIHRpbWUgdG9wIGVkZ2VzIikgKyAKICB4bGFiKCIiKSArIAogIHlsYWIoIlRpbWUgKG1pbikiKSArCiAgdGhlbWUoYXhpcy50ZXh0Lng9ZWxlbWVudF90ZXh0KGFuZ2xlPTQ1LGhqdXN0PTEsdmp1c3Q9MSkpCmBgYAoKCgoKIyMgQWxsIHNwZWVkIHRpbWVzZXJpZXMgcGVyIHdheV9pZAoKIyMjIEF2ZyBzcGVlZCBieSBzZXNzaW9uIGFuZCB0aGVuIHRpbWUuCgpgYGB7ciBlY2hvPUZBTFNFLCBtZXNzYWdlPUZBTFNFLCB3YXJuaW5nPUZBTFNFfQpsYXBwbHkoMTo5LEZVTiA9IHBsb3QudGltZXNlcmllcykgCmBgYAoKIyMjIyBIb3VyCmBgYHtyIGVjaG89RkFMU0UsIG1lc3NhZ2U9RkFMU0UsIHdhcm5pbmc9RkFMU0V9CnBsb3Quc3BlZWRfYXZnKGRmX3N1cGVyaG90ZWRnZXNfYXByaWwxNnB0LCBob3VyKQpgYGAKCiMjIyMgV2VlayBkYXkKYGBge3IgZWNobz1GQUxTRSwgbWVzc2FnZT1GQUxTRSwgd2FybmluZz1GQUxTRX0KcGxvdC5zcGVlZF9hdmcoZGZfc3VwZXJob3RlZGdlc19hcHJpbDE2cHQsIHdkYXkpCmBgYAoKIyMjIyBEYXkKYGBge3IgZWNobz1GQUxTRSwgbWVzc2FnZT1GQUxTRSwgd2FybmluZz1GQUxTRX0KcGxvdC5zcGVlZF9hdmcoZGZfc3VwZXJob3RlZGdlc19hcHJpbDE2cHQsIGRheSkKYGBgCgoKIyMjQXZlcmFnZSBvZiBzcGVlZCBvZiBldmVyeSBwb2ludC4KIyMjI051bWJlciBvZiBzZXNzaW9ucyAKCiAgKiBXZSBjYW4gc2VlIHVzdWFsbHkgYSBpbmNyZW1lbnRhbCBvZiBudW1iZXIgb2Ygc2Vzc2lvbnMgYWxvbmcgdGhlIHdlZWsuIEJlaW5nIAogIHRodXJzZGF5cyBhbmQgZnJpZGF5cyB0aGUgb25lIHdpdGggbW9zdCBzZXNzaW9ucy4gCiAgKlRoZSBkcm9wIGluIGRheSAyNXRoIGl0IGlzIGJlY2F1c2UgaG9saWRheS4KCmBgYHtyIGVjaG89RkFMU0UsIG1lc3NhZ2U9RkFMU0V9CmxhcHBseSgxOjksIEZVTiA9IHRzZXJpZXNfbnNlc3Npb24pCmBgYAoKIyMjIEF2ZXJhZ2Ugc3BlZWQKYGBge3IgZWNobz1GQUxTRSwgbWVzc2FnZT1GQUxTRX0KbGFwcGx5KDE6OSwgRlVOID0gdHNlcmllc19zcGVlZCkKYGBgCgojIyNJbnRlcnNlc3Npb24gdGltZQpgYGB7ciBlY2hvPUZBTFNFLCBtZXNzYWdlPUZBTFNFLCB3YXJuaW5nPUZBTFNFfQpsYXBwbHkoMTo5LCBGVU4gPSB0c2VyaWVzX2ludGVyKQpgYGAKCiMjRGVuc2l0eSBsaW5lcyBhdmVyYWdlIHNwZWVkIGFsbCB0b2dldGhlcgpgYGB7ciBlY2hvPUZBTFNFfQpnZ3Bsb3RseShkZW5zKQpgYGAKIyMgU3RhbmRhcmQgZGV2aWF0aW9uCgojIyMgQnkgaG91cgpgYGB7ciBlY2hvPUZBTFNFfQpkZl9zdXBlcmhvdGVkZ2VzX2FwcmlsMTZwdCAlPiUgCiAgZmlsdGVyKCB3ZGF5KHRpbWUpICE9IDEgLCB3ZGF5KHRpbWUpICE9IDcgKSAlPiUgCiAgZ3JvdXBfYnkod2F5X2lkLHNlc3Npb25faWQsIGhvdXIgPSBob3VyKHRpbWUpLCBoZWFkaW5nKSAlPiUKICBzdW1tYXJpc2Uoc3BlZWRfc2VzcyA9IG1lYW4oc3BlZWQqMTgvNSkpICU+JQogIGdyb3VwX2J5KHdheV9pZCwgaG91ciwgaGVhZGluZykgJT4lCiAgc3VtbWFyaXNlKGF2Z19zcGVlZCA9IG1lYW4oc3BlZWRfc2VzcyksIHNkID0gc2Qoc3BlZWRfc2VzcykpICU+JSAKICBtZXJnZSh5ID0gZGZfb3NtX2VkZ2VfaWRzLCB1c2luZyA9IHdheV9pZCkgJT4lIAogIGdncGxvdChhZXMoeD1hdmdfc3BlZWQsIHk9c2QsIGNvbG9yID0gaGVhZGluZykpICsKICBnZW9tX3BvaW50KCkgKwogIGdlb21fc21vb3RoKCkgKwogIGZhY2V0X3dyYXAofiBhZGRyZXNzKSArIAogIGdndGl0bGUoIkJ5IGhvdXIgYXZnLiBzcGVlZCBBcHJpbDE2IikKYGBgCgojIyMgQnkgZGF5IGFuZCBob3VyCmBgYHtyIGVjaG89RkFMU0V9CmRmX3N1cGVyaG90ZWRnZXNfYXByaWwxNnB0ICU+JSAKICBmaWx0ZXIoIHdkYXkodGltZSkgIT0gMSAsIHdkYXkodGltZSkgIT0gNyApICU+JSAKICBncm91cF9ieSh3YXlfaWQsc2Vzc2lvbl9pZCwgZGF5ID0gd2RheSh0aW1lKSwgaG91ciA9IGhvdXIodGltZSksIGhlYWRpbmcpICU+JSAKICBzdW1tYXJpc2Uoc3BlZWRfc2VzcyA9IG1lYW4oc3BlZWQqMTgvNSkpICU+JSAKICBncm91cF9ieSh3YXlfaWQsIGRheSwgaG91ciwgaGVhZGluZykgJT4lIAogIHN1bW1hcmlzZShhdmdfc3BlZWQgPSBtZWFuKHNwZWVkX3Nlc3MpLCBzZD0gc2Qoc3BlZWRfc2VzcykpICU+JSAKICBtZXJnZSh5ID0gZGZfb3NtX2VkZ2VfaWRzLCB1c2luZyA9IHdheV9pZCkgJT4lIAogIGdncGxvdChhZXMoeD1hdmdfc3BlZWQsIHk9c2QsIGNvbG9yID0gaGVhZGluZykpICsKICBnZW9tX3BvaW50KGFscGhhID0gMS8zKSArCiAgZ2VvbV9zbW9vdGgoKSArCiAgZmFjZXRfd3JhcCh+IGFkZHJlc3MpICsgCiAgZ2d0aXRsZSgiQnkgZGF5IGFuZCBob3VyIGF2Zy5zcGVlZCIpCmBgYAoKIyMjIEJ5IHNlc3Npb24gCmBgYHtyIGVjaG89RkFMU0V9CmRmX3N1cGVyaG90ZWRnZXNfYXByaWwxNnB0ICU+JSAKICBncm91cF9ieSh3YXlfaWQsIHNlc3Npb25faWQsIGhvdXIgPSBob3VyKHRpbWUpLCBoZWFkaW5nKSAlPiUgCiAgc3VtbWFyaXNlKGF2Z19zcGVlZCA9IG1lYW4oc3BlZWQqMTgvNSksIHNkID0gc2Qoc3BlZWQpKSAlPiUgCiAgbWVyZ2UoeSA9IGRmX29zbV9lZGdlX2lkcywgdXNpbmcgPSB3YXlfaWQpICU+JSAKICBnZ3Bsb3QoYWVzKHg9YXZnX3NwZWVkLCB5PXNkLCBjb2xvciA9IGhlYWRpbmcpKSArCiAgZ2VvbV9wb2ludChhbHBoYSA9IDEvNSkgKwogIGdlb21fc21vb3RoKGFlcyhjb2xvdXIgPSBoZWFkaW5nLCBmaWxsID0gaGVhZGluZykpICsKICBmYWNldF93cmFwKH5hZGRyZXNzKSArIAogIGdndGl0bGUoIkJ5IHNlc3Npb24gcGVyIGhvdXIgYXZnLiBzcGVlZCBBcHJpbDE2IikKYGBgCgo8IS0tCiMjIEFsbCBzcGVlZCB0aW1lc2VyaWVzIHBlciB3YXlfaWQKQXZlcmFnZSBvZiBzcGVlZCBvZiBldmVyeSBwb2ludC4KCmBgYHtyIGVjaG89RkFMU0UsIG1lc3NhZ2U9RkFMU0V9CmxhcHBseSgxOjksIEZVTiA9IHRzZXJpZXMpCmBgYAotLT4KCgoKCg==